<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!-- saved from url=(0028)http://jdbi.org/archive.html -->
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></meta>


<title>abacus-common</title>

<script type="text/javascript" src="./css/ga.js"></script>
<script type="text/javascript">
	if (top.location != self.location)
		top.location.replace(self.location);
</script>

<link href="./css/css" rel="stylesheet" type="text/css"></link>
<link href="./css/css(1)" rel="stylesheet" type="text/css"></link>
<link rel="stylesheet" href="./css/syntax.css" type="text/css"></link>
<link rel="stylesheet" href="./css/screen.css" type="text/css"></link>

<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-65247258-1', 'auto');
  ga('send', 'pageview');
</script>

</head>
<body>
	<div id="site">
		<h1>
			<a href="./index.html">abacus-common</a> <span id="navigation"> <a href="./docs.html">Docs</a> | <a href="./download.html">Download</a> | <a
				href="./api-docs/index.html">Javadoc</a> | <a href="./faq.html">FAQ</a> | <a href="./community.html">Community</a>
			</span>
		</h1>
	</div>

	<div id="content">

		<div id="page">

			<h1>Partitioning/Distribution</h1>
			<p>
				Partitioning/Distribution is supported by the <a href="./api-docs/com/landawn/abacus/SliceSelector.html">SliceSelector</a> and <a
					href="./api-docs/com/landawn/abacus/DataSourceSelector.html">DataSourceSelector</a> and
				integrated with <a href="./api-docs/com/landawn/abacus/util/SQLExecutor.html">SQLExecutor</a>. Here are the steps to implement it by abacus-common:
			</p>

			<li>Define the logic for table partitioning and data source distribution by implementing <i>SliceSelector</i> and <i>DataSourceSelector</i>.
			</li>

			<li>Configure the implementation classes in data source xml file by schema <a href="./DataSource.xsd">DataSource.xsd</a></li>

			<li>Initialized <i>SQLExecutor</i> with the <i>DataSourceManager</i> created with the data source xml file by <a href="./api-docs/com/landawn/abacus/util/JdbcUtil.html">JdbcUtil</a>
			</li>

			<li>All the SQL operations will be dispatched to the target table or data source by the logic defined in <i>SliceSelector</i> and <i>DataSourceSelector</i></li>

			<li>The <i>queryAll</i> and <i>findAll</i> methods in <i>SQLExecutor</i> are designed to query single/multiple SQL scripts from single/multiple data sources
			</li>

			<p></p>
			<p>
				We should not do it just because it's a challenge thing to do. Any unnecessary partitioning/shared should be avoided. Actually, a lot of load/performance issues can be resolved: 
				<li>Tuning the code and SQL scripts from application level</li>
				<li>Upgrading disk to SSD could improve performance more than 10 times</li>
				<li>Introducing cache (Memcached/Redis)</li>
			</p>

		</div>

	</div>
</body>

</html>